package com.qf.dao;

import com.qf.entity.Emp;

import java.sql.SQLException;
import java.util.List;

public interface EmpDao {
    //查询数据的条数
    Integer selectEmpCount(String e_name,String e_phone_number) throws SQLException;

    //分页查询店员的信息
    List<Emp> selectEmp(String e_name,String e_phone_number,Integer pageSize,Integer currentPageNo) throws SQLException;

    //根据id查店员信息
    Emp selectEmpById(int e_id) throws SQLException;

    //修改店员信息
    int updateEmp(Emp emp) throws SQLException;

    //增加店员信息
    int addEmp(Emp emp) throws SQLException;

    //删除店员信息
    int deleteEmp(int e_id) throws SQLException;
}
